Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_TRIGGERS

`ALL_TRIGGERS` describes owned by the current user and triggers on tables owned by the current user. If the user has the `CREATE ANY TRIGGER` privilege, then this view describes all triggers in the database.

Related Views

- `DBA_TRIGGERS` describes all triggers in the database.

- `USER_TRIGGERS` describes all triggers owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` |  | Owner of the trigger
`TRIGGER_NAME` | `VARCHAR2(30)` |  | Name of the trigger
`TRIGGER_TYPE` | `VARCHAR2(16)` |  | When the trigger fires: `BEFORE STATEMENT`, `BEFORE EACH ROW`, `BEFORE EVENT`, `AFTER STATEMEN`T, `AFTER EACH ROW`, and `AFTER EVENT`
`TRIGGERING_EVENT` | `VARCHAR2(227)` |  | The DML, DDL, or database event that fires the trigger. For a listing of triggering events, see the `CREATE TRIGGER` statement in Oracle Database SQL Reference.
`TABLE_OWNER` | `VARCHAR2(30)` |  | Owner of the table on which the trigger is defined
`BASE_OBJECT_TYPE` | `VARCHAR2(16)` |  | Base object on which the trigger is defined: `TABLE, VIEW`, `SCHEMA`, or `DATABASE`
`TABLE_NAME` | `VARCHAR2(30)` |  | If the base object type of the trigger is `SCHEMA` or `DATABASE`, then this column is `NULL`; if the base object type of the trigger is `TABLE` or `VIEW`, this columns indicates the table/view name on which the trigger is defined
`COLUMN_NAME` | `VARCHAR2(4000)` |  | Name of the nested table column (if nested table trigger), else null
`REFERENCING_NAMES` | `VARCHAR2(128)` |  | Names used for referencing `OLD` and `NEW` column values from within the trigger
`WHEN_CLAUSE` | `VARCHAR2(4000)` |  | Must evaluate to `TRUE` for `TRIGGER_BODY` to execute
`STATUS` | `VARCHAR2(8)` |  | Indicates whether the trigger is enabled (`ENABLED`) or disabled (`DISABLED`)
`DESCRIPTION` | `VARCHAR2(4000)` |  | Trigger description; useful for re-creating a trigger creation statement
`ACTION_TYPE` | `VARCHAR2(11)` |  | Action type of the trigger body (`CALL` or `PL/SQL`)
`TRIGGER_BODY` | `LONG` |  | Statements executed by the trigger when it fires